Stored Procedures [dbo].[BAEEventGetFunctionPricing]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetFunctionPricing
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@productCodevarchar(31)31
@pMemberTypevarchar(10)10
SQL Script
create procedure [dbo].[BAEEventGetFunctionPricing] @productCode as
varchar(31),
    @pMemberType AS varchar(10)
AS
    SELECT RATE_1 AS 'EarlyRate', RATE_2  AS 'NormalRate', RATE_3 AS 'LateRate'
    FROM Product_Price
    WHERE PRODUCT_CODE = @productCode AND CUSTOMER_TYPE = @pMemberType

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved